package com.example.demo.main;

public class PraticeSql {
    public static void main(String[] args) {
//        String t_o = "select  from OrderItem order by";
            String fo_on = "select count(distinct teacher) as 教师人数 from c";
            String fo_tw = "select avg(age) as 平均年龄 from s where s.sex = \"女\"";
            String fo_th = "select avg(sc.grade) from sc,c where sc.c = c.c and c.name = \"刘老师\" ";
            String fo_fo = "select * from s,sc where";
            String fo_fi = " select sname from s where \"学号\" > (select 学号 from s where sname = \"王同学\") as  ";
    }
}